Видео ютуба по тегу Optimise Aggregate Postgres Query With Subqueries

Optimize Your PostgreSQL Query with Conditional Aggregation for Better Performance
Optimize Your PostgreSQL Query with Conditional Aggregation for Better Performance